SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
                        `id` int NOT NULL AUTO_INCREMENT,
                        `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
                        `birthday` datetime DEFAULT NULL,
                        `sex` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
                        `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
                        PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (3, 'TOM', '1969-12-31 00:00:00', '女', '上海');
INSERT INTO `user` VALUES (4, 'Tom', '1969-12-31 00:00:00', '女', '上海');
INSERT INTO `user` VALUES (5, '赵六', '2020-06-02 00:00:00', '男', '深圳');
INSERT INTO `user` VALUES (6, '赵六', '2020-06-02 00:00:00', '男', '深圳');
INSERT INTO `user` VALUES (7, 'Tom', '1969-12-31 00:00:00', '女', '上海');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;